Field Explorer
Overview
The Field Explorer is used to insert, modify or delete fields on the Design and Preview tabs of Crystal Reports. You'll see the Field Explorer after you have:
- selected a data source for a new report
- clicked the Insert Fields button on the Standard toolbar
- selected Field Object from the Insert menu.
The Field Explorer displays a tree view of database fields and special fields that you can add to your report. It also shows formula fields, SQL expression fields, parameter fields, group name fields, and running total fields that you have defined for use in your report.
Fields that have already been added to the report, or fields that have been used by other fields (such as formula fields, groups, running total fields, summaries, and so on) have a check mark in front of them.
Toolbar and shortcut menu
The toolbar provides buttons with tool tips and hot-key combinations. You can right-click any item in the tree view to bring up a shortcut menu.
The toolbar and the shortcut menu offer these functions:
- Insert to Report
Use this option to add a field to the report. You can insert more than one field at a time by selecting multiple fields, right-clicking, and choosing Insert to Report.
Alternatively, to insert a field, you can drag and drop it in the Design or Preview tabs.
- Browse
Use this option to browse data for a database field or formula field.
When you right-click a database field, the shortcut menu has Insert to Report and Browse Data enabled.
- New
Use this option to create a formula field, SQL expression field, parameter field or running total field.
- Edit
Use this option to modify an existing formula field, SQL expression field, parameter field or running total field.
- Rename
Use this option to modify the name of an existing formula field, SQL expression field, parameter field or running total field.
- Delete
Use this option to remove a formula field, SQL expression field, parameter field or running total field. You can also select multiple fields, right-click, and choose Delete to remove them all at once.
- Move Up (or Down)
Use this option to change the order of parameter fields.
When you right-click a parameter field, all the functions except Browse Data are enabled.
- Show Field Type
Use this option to see the field type (string, number, and so on) when you're looking at a list of database fields.
Related topics
Field Object command
Subtotal command
Creating a parameter field